<%-- 
    Document   : crearconvenio
    Created on : 5/11/2013, 06:55:59 PM
    Author     : Chapas
--%>
<%@page import="java.sql.ResultSet"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<jsp:useBean class="clases.ControlDatos" scope="session" id="cdatos"></jsp:useBean>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
    <head>
        <meta http-equiv="content-type" content="text/html; charset=utf-8" />
        <title>Crear Convenios</title>
        <meta name="keywords" content="" />
        <meta name="description" content="" />
        <link href="styles.css" rel="stylesheet" type="text/css" media="screen" />
    </head>
    <body>

        <div id="bg">

            <!-- header begins -->
            <div id="header">
                <div id="logo"><h1><a href="#">Banca Online</a></h1></div>
                <div id="buttons">
                    <ul>
                        <li class="first"><a href="index.jsp"  title="">Inicio</a></li>
                        <li><a href="adminusuarios.jsp" title="">Adm. Usuarios</a></li>
                        <li><a href="adminconsorcios.jsp" title="">Adm. Consorcio</a></li>
                        <li><a href="adminconvenios.jsp" title="">Adm. Convenio</a></li>
                        <li><a href="admincuentas.jsp" title="">Adm. Cuentas</a></li>



                    </ul>
                </div>
            </div>
            <!-- header ends -->

            <div id="main">
                <div id="maintop"><img src="images/spaser.gif" alt="" /></div>
                <!-- content begins -->
                <div id="content">
                    <div id="right">
                        <div id="archives">
                            <h2>Convenios</h2>
                            <div class="tit_b">
                                <ul>

                                    <li><a href="adminconvenios.jsp" title="">Adm. Convenio</a></li>

                                </ul>
                            </div>

                        </div>
                    </div>
                    <div id="left">
                        <div id="img_b"></div>
                        <div class="text">
                            <h1>Modificar Convenio</h1>
                            <p>Se pueden actualizar los datos indicados a continuación.</p>
                            <br />


                            <h2><a href="">Agregar Servicios por Cuenta</a></h2><br> 


                            <form action="ejecutarconsorcio.jsp">
                                Convenio:
                                <select name="convenio" id="convenio">
                                    <%
                                                ResultSet result=cdatos.consultaConvenios();
                                                while(result.next()){
                                                    out.println("<option>");
                                                    out.println(result.getString(1));
                                                    out.println("</option>");
                                                }
                                            %>
                                </select><br>

                                Servicio:
                                <select name="servicio" id="servicio">
                                    <%
                                                ResultSet result2=cdatos.consultaServicios();
                                                while(result.next()){
                                                    out.println("<option"
                                                            + result2.getString(1)+">");
                                                    out.println(result2.getString(2));
                                                    out.println("</option>");
                                                }
                                            %>
                                </select><br></br>

                                Cuenta:
                                <select name="cuenta" id="cuenta">
                                    <%
                                                ResultSet result3=cdatos.consultaCuentas();
                                                while(result.next()){
                                                    out.println("<option>");
                                                    out.println(result3.getString(1));
                                                    out.println("</option>");
                                                }
                                            %>
                                </select><br>

                               
                                    Estado:
                                <select name="estado" id="estado">
                                    <option>Inactivo</option>
                                    <option>Activo</option>

                                </select><br><br>
                                <input type="submit" value="Crear!"/>
                            </form>

                            <br /><br />
                        </div>
                    </div>
                    <div style="clear: both"></div>

                </div>

                <!-- content ends -->
                <div id="mainbot"><img src="images/spaser.gif" alt="" /></div>
            </div>
            <!-- footer begins -->
            <div id="footer">
                <p>Copyright &copy; 2011. <a href="http://www.flashtemplatesdesign.com/" title="Web Design">Web Design</a> by <a href="http://www.flashtemplatesdesign.com/" title="Flash Website Templates">Flash Website Templates</a></p>
                <p><a href="#">Privacy Policy</a> | <a href="#">Terms of Use</a> | <a href="http://validator.w3.org/check/referer" title="This page validates as XHTML 1.0 Transitional"><abbr title="eXtensible HyperText Markup Language">XHTML</abbr></a> | <a href="http://jigsaw.w3.org/css-validator/check/referer" title="This page validates as CSS"><abbr title="Cascading Style Sheets">CSS</abbr></a></p></div>
            <!-- footer ends -->
            <center><span style="width: 100%; font-family: helvetica; font-size: 10px;">Universidad de San Carlos de Guatemala <a href="http://www.usac.edu.gt" style="font-family: helvetica; color: gray; font-size: 11px;">FIUSAC</a> | <a href="http://www.ingenieria.usac.edu.gt" style="font-family: helvetica; color: gray; font-size: 11px;">ECYS</a></span></center>
        </div>
    </body>
</html>
